package org.zht.dormpro.dorm.mapper;

import org.apache.ibatis.annotations.*;
import org.zht.dormpro.auth.bean.PageBean;
import org.zht.dormpro.auth.model.SysRole;
import org.zht.dormpro.dorm.model.TbCollege;

import java.util.List;

public interface TbCollegeMapper {
    @Delete({
        "delete from tb_college",
        "where id = #{id,jdbcType=INTEGER}"
    })
    int deleteByPrimaryKey(Integer id);


    int insertSelective(TbCollege record);

    @Select({
        "select",
        "id, col_id, col_name, col_remark, col_append, col_status",
        "from tb_college",
        "where id = #{id,jdbcType=INTEGER}"
    })
    @ResultMap("org.zht.dormpro.dorm.mapper.TbCollegeMapper.BaseResultMap")
    TbCollege selectByPrimaryKey(Integer id);

    int updateByPrimaryKeySelective(TbCollege record);

    List<TbCollege> getAllCollege(@Param("all") int all);

    List<TbCollege> getAllCollegeByCondition(PageBean pageBean);
}